Pandas Profiling Report - Cleaned DataFrame

Dataset statistics

Number of variables	17
Number of observations	19001
Missing cells	7531
Missing cells (%)	2.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.5 MiB
Average record size in memory	136.0 B

Variable types

Numeric	11
Categorical	5
DateTime	1

Warnings

`name` has a high cardinality: 18780 distinct values	High cardinality
`host_name` has a high cardinality: 6307 distinct values	High cardinality
`neighbourhood` has a high cardinality: 215 distinct values	High cardinality
`last_review` has 3758 (19.8%) missing values	Missing
`reviews_per_month` has 3758 (19.8%) missing values	Missing
`df_index` is uniformly distributed	Uniform
`name` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`id` has unique values	Unique
`minimum_nights` has 5003 (26.3%) zeros	Zeros
`number_of_reviews` has 3758 (19.8%) zeros	Zeros
`availability_365` has 6970 (36.7%) zeros	Zeros

Reproduction

Analysis started	2023-05-06 15:32:08.225078
Analysis finished	2023-05-06 15:32:35.878003
Duration	27.65 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	19001
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10003.44161
Minimum	0
Maximum	19999
Zeros	1
Zeros (%)	< 0.1%
Memory size	148.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1011
Q1	5013
median	10005
Q3	14995
95-th percentile	19003
Maximum	19999
Range	19999
Interquartile range (IQR)	9982

Descriptive statistics

Standard deviation	5769.642118
Coefficient of variation (CV)	0.5767657116
Kurtosis	-1.197212199
Mean	10003.44161
Median Absolute Deviation (MAD)	4991
Skewness	-0.0006857784065
Sum	190075394
Variance	33288770.16
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
17714	1	< 0.1%
9518	1	< 0.1%
15661	1	< 0.1%
13612	1	< 0.1%
3371	1	< 0.1%
1322	1	< 0.1%
7465	1	< 0.1%
5416	1	< 0.1%
19747	1	< 0.1%
Other values (18991)	18991	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
19999	1	< 0.1%
19998	1	< 0.1%
19997	1	< 0.1%
19996	1	< 0.1%
19995	1	< 0.1%

id
Real number (ℝ_≥0)

UNIQUE

Distinct	19001
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	18830405.22
Minimum	2539
Maximum	36485609
Zeros	0
Zeros (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	2539
5-th percentile	1177971
Q1	9355498
median	19387536
Q3	28919516
95-th percentile	35240782
Maximum	36485609
Range	36483070
Interquartile range (IQR)	19564018

Descriptive statistics

Standard deviation	10969857.88
Coefficient of variation (CV)	0.5825609034
Kurtosis	-1.225663309
Mean	18830405.22
Median Absolute Deviation (MAD)	9804926
Skewness	-0.06687371468
Sum	3.577965297 × 10¹¹
Variance	1.203377819 × 10¹⁴
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32493112	1	< 0.1%
36308266	1	< 0.1%
15509545	1	< 0.1%
13073701	1	< 0.1%
20775370	1	< 0.1%
2728293	1	< 0.1%
169152	1	< 0.1%
3251638	1	< 0.1%
21308702	1	< 0.1%
8162587	1	< 0.1%
Other values (18991)	18991	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2539	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5121	1	< 0.1%
5203	1	< 0.1%

Value	Count	Frequency (%)
36485609	1	< 0.1%
36485057	1	< 0.1%
36480292	1	< 0.1%
36479723	1	< 0.1%
36478343	1	< 0.1%

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	18780
Distinct (%)	98.9%
Missing	7
Missing (%)	< 0.1%
Memory size	148.6 KiB

Hillside Hotel	7
Brooklyn Apartment	7
Home away from home	6
Private Room	6
New york Multi-unit building	5
Other values (18775)	18963

Length

Max length	179
Median length	36
Mean length	36.75139518
Min length	1

Characters and Unicode

Total characters	698056
Distinct characters	504
Distinct categories	20 ?
Distinct scripts	11 ?
Distinct blocks	17 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18619 ?
Unique (%)	98.0%

Sample

1st row	Private Lg Room 15 min to Manhattan
2nd row	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC
3rd row	Voted #1 Location Quintessential 1BR W Village Apt
4th row	Spacious 1 bedroom apartment 15min from Manhattan
5th row	Big beautiful bedroom in huge Bushwick apartment

Value	Count	Frequency (%)
Hillside Hotel	7	< 0.1%
Brooklyn Apartment	7	< 0.1%
Home away from home	6	< 0.1%
Private Room	6	< 0.1%
New york Multi-unit building	5	< 0.1%
Private room in Manhattan	5	< 0.1%
Cozy Room	5	< 0.1%
Private room in Williamsburg	4	< 0.1%
Cozy Private Room	4	< 0.1%
Cozy home away from home	3	< 0.1%
Other values (18770)	18942	99.7%
(Missing)	7	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
in	6594	5.7%
room	4014	3.5%
	3161	2.7%
bedroom	3016	2.6%
private	2874	2.5%
apartment	2658	2.3%
cozy	2017	1.7%
apt	1765	1.5%
brooklyn	1623	1.4%
studio	1556	1.3%
Other values (6673)	86285	74.7%

Most occurring characters

Value	Count	Frequency (%)
	97219	13.9%
e	48065	6.9%
o	47895	6.9%
t	40878	5.9%
a	40431	5.8%
r	38293	5.5%
i	36980	5.3%
n	36723	5.3%
l	20035	2.9%
m	19434	2.8%
Other values (494)	272103	39.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	469006	67.2%
Uppercase Letter	102950	14.7%
Space Separator	97221	13.9%
Other Punctuation	12924	1.9%
Decimal Number	9521	1.4%
Dash Punctuation	2620	0.4%
Other Letter	976	0.1%
Math Symbol	970	0.1%
Close Punctuation	621	0.1%
Open Punctuation	568	0.1%
Other values (10)	679	0.1%

Most frequent character per category

Value	Count	Frequency (%)
房	36	3.7%
间	22	2.3%
中	21	2.2%
拉	19	1.9%
法	18	1.8%
盛	18	1.8%
家	16	1.6%
温	15	1.5%
的	15	1.5%
馨	13	1.3%
Other values (299)	783	80.2%

Value	Count	Frequency (%)
e	48065	10.2%
o	47895	10.2%
t	40878	8.7%
a	40431	8.6%
r	38293	8.2%
i	36980	7.9%
n	36723	7.8%
l	20035	4.3%
m	19434	4.1%
s	18729	4.0%
Other values (48)	121543	25.9%

Value	Count	Frequency (%)
★	95	28.5%
❤	66	19.8%
☆	31	9.3%
⭐	19	5.7%
♥	14	4.2%
✨	13	3.9%
❥	13	3.9%
✰	8	2.4%
✿	7	2.1%
☀	6	1.8%
Other values (27)	61	18.3%

Value	Count	Frequency (%)
B	11484	11.2%
S	10080	9.8%
C	8176	7.9%
A	7545	7.3%
R	6917	6.7%
P	5740	5.6%
E	5345	5.2%
L	5288	5.1%
M	4520	4.4%
N	4373	4.2%
Other values (23)	33482	32.5%

Value	Count	Frequency (%)
,	3504	27.1%
!	3055	23.6%
/	1958	15.2%
.	1683	13.0%
&	1234	9.5%
'	425	3.3%
*	329	2.5%
:	225	1.7%
#	212	1.6%
"	111	0.9%
Other values (9)	188	1.5%

Value	Count	Frequency (%)
1	3413	35.8%
2	2526	26.5%
3	931	9.8%
5	800	8.4%
0	768	8.1%
4	459	4.8%
6	233	2.4%
8	150	1.6%
7	147	1.5%
9	94	1.0%

Value	Count	Frequency (%)
+	476	49.1%
\|	359	37.0%
~	99	10.2%
=	11	1.1%
>	9	0.9%
<	7	0.7%
￫	6	0.6%
√	2	0.2%
×	1	0.1%

Value	Count	Frequency (%)
(	544	95.8%
[	16	2.8%
{	4	0.7%
【	3	0.5%
《	1	0.2%

Value	Count	Frequency (%)
)	596	96.0%
]	17	2.7%
}	4	0.6%
】	3	0.5%
》	1	0.2%

Value	Count	Frequency (%)
-	2589	98.8%
—	16	0.6%
–	15	0.6%

Value	Count	Frequency (%)
	97219	> 99.9%
	2	< 0.1%

Value	Count	Frequency (%)
’	89	86.4%
”	14	13.6%

Value	Count	Frequency (%)
️	66	88.0%
︎	9	12.0%

Value	Count	Frequency (%)
“	15	78.9%
‘	4	21.1%

Value	Count	Frequency (%)
ﾞ	7	70.0%
ｰ	3	30.0%

Value	Count	Frequency (%)
^	6	85.7%
`	1	14.3%

Value	Count	Frequency (%)
	72	100.0%

Value	Count	Frequency (%)
$	34	100.0%

Value	Count	Frequency (%)
_	20	100.0%

Value	Count	Frequency (%)
²	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	571873	81.9%
Common	125049	17.9%
Han	878	0.1%
Inherited	75	< 0.1%
Cyrillic	71	< 0.1%
Katakana	45	< 0.1%
Hebrew	31	< 0.1%
Georgian	12	< 0.1%
Hiragana	12	< 0.1%
Hangul	8	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
房	36	4.1%
间	22	2.5%
中	21	2.4%
拉	19	2.2%
法	18	2.1%
盛	18	2.1%
家	16	1.8%
温	15	1.7%
的	15	1.7%
馨	13	1.5%
Other values (244)	685	78.0%

Value	Count	Frequency (%)
	97219	77.7%
,	3504	2.8%
1	3413	2.7%
!	3055	2.4%
-	2589	2.1%
2	2526	2.0%
/	1958	1.6%
.	1683	1.3%
&	1234	1.0%
3	931	0.7%
Other values (92)	6937	5.5%

Value	Count	Frequency (%)
e	48065	8.4%
o	47895	8.4%
t	40878	7.1%
a	40431	7.1%
r	38293	6.7%
i	36980	6.5%
n	36723	6.4%
l	20035	3.5%
m	19434	3.4%
s	18729	3.3%
Other values (61)	224410	39.2%

Value	Count	Frequency (%)
ﾝ	7	15.6%
ﾄ	5	11.1%
ｯ	3	6.7%
ﾀ	3	6.7%
ｳ	3	6.7%
ｸ	3	6.7%
ﾐ	2	4.4%
ｽ	2	4.4%
ｴ	1	2.2%
ｻ	1	2.2%
Other values (15)	15	33.3%

Value	Count	Frequency (%)
а	10	14.1%
н	7	9.9%
т	7	9.9%
о	6	8.5%
с	6	8.5%
к	5	7.0%
м	4	5.6%
е	4	5.6%
я	3	4.2%
р	3	4.2%
Other values (9)	16	22.5%

Value	Count	Frequency (%)
י	5	16.1%
ו	5	16.1%
ב	4	12.9%
ר	4	12.9%
ע	2	6.5%
ת	2	6.5%
ה	2	6.5%
ד	1	3.2%
ש	1	3.2%
ל	1	3.2%
Other values (4)	4	12.9%

Value	Count	Frequency (%)
따	1	12.5%
뜻	1	12.5%
한	1	12.5%
작	1	12.5%
은	1	12.5%
건	1	12.5%
물	1	12.5%
웃	1	12.5%

Value	Count	Frequency (%)
の	5	41.7%
お	2	16.7%
に	1	8.3%
い	1	8.3%
な	1	8.3%
で	1	8.3%
す	1	8.3%

Value	Count	Frequency (%)
️	66	88.0%
︎	9	12.0%

Value	Count	Frequency (%)
ॐ	2	100.0%

Value	Count	Frequency (%)
ღ	12	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	696288	99.7%
CJK	878	0.1%
Punctuation	187	< 0.1%
None	179	< 0.1%
Misc Symbols	176	< 0.1%
Dingbats	130	< 0.1%
VS	75	< 0.1%
Cyrillic	71	< 0.1%
Hebrew	31	< 0.1%
Georgian	12	< 0.1%
Other values (7)	29	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	97219	14.0%
e	48065	6.9%
o	47895	6.9%
t	40878	5.9%
a	40431	5.8%
r	38293	5.5%
i	36980	5.3%
n	36723	5.3%
l	20035	2.9%
m	19434	2.8%
Other values (86)	270335	38.8%

Value	Count	Frequency (%)
❤	66	50.8%
✨	13	10.0%
❥	13	10.0%
✰	8	6.2%
✿	7	5.4%
✪	5	3.8%
✴	4	3.1%
✦	4	3.1%
✮	3	2.3%
✩	2	1.5%
Other values (3)	5	3.8%

Value	Count	Frequency (%)
房	36	4.1%
间	22	2.5%
中	21	2.4%
拉	19	2.2%
法	18	2.1%
盛	18	2.1%
家	16	1.8%
温	15	1.7%
的	15	1.7%
馨	13	1.5%
Other values (244)	685	78.0%

Value	Count	Frequency (%)
’	89	47.6%
•	34	18.2%
—	16	8.6%
–	15	8.0%
“	15	8.0%
”	14	7.5%
‘	4	2.1%

Value	Count	Frequency (%)
★	95	54.0%
☆	31	17.6%
♥	14	8.0%
☀	6	3.4%
♀	5	2.8%
⚡	4	2.3%
⚓	3	1.7%
☺	3	1.7%
♛	2	1.1%
♕	2	1.1%
Other values (6)	11	6.2%

Value	Count	Frequency (%)
⭐	19	10.6%
à	15	8.4%
ó	9	5.0%
｡	7	3.9%
·	7	3.9%
é	7	3.9%
ﾞ	7	3.9%
ﾝ	7	3.9%
￫	6	3.4%
²	6	3.4%
Other values (51)	89	49.7%

Value	Count	Frequency (%)
ॐ	2	100.0%

Value	Count	Frequency (%)
️	66	88.0%
︎	9	12.0%

Value	Count	Frequency (%)
™	1	100.0%

Value	Count	Frequency (%)
√	2	100.0%

Value	Count	Frequency (%)
ღ	12	100.0%

Value	Count	Frequency (%)
а	10	14.1%
н	7	9.9%
т	7	9.9%
о	6	8.5%
с	6	8.5%
к	5	7.0%
м	4	5.6%
е	4	5.6%
я	3	4.2%
р	3	4.2%
Other values (9)	16	22.5%

Value	Count	Frequency (%)
▲	2	100.0%

Value	Count	Frequency (%)
の	5	41.7%
お	2	16.7%
に	1	8.3%
い	1	8.3%
な	1	8.3%
で	1	8.3%
す	1	8.3%

Value	Count	Frequency (%)
י	5	16.1%
ו	5	16.1%
ב	4	12.9%
ר	4	12.9%
ע	2	6.5%
ת	2	6.5%
ה	2	6.5%
ד	1	3.2%
ש	1	3.2%
ל	1	3.2%
Other values (4)	4	12.9%

Value	Count	Frequency (%)
따	1	12.5%
뜻	1	12.5%
한	1	12.5%
작	1	12.5%
은	1	12.5%
건	1	12.5%
물	1	12.5%
웃	1	12.5%

Value	Count	Frequency (%)
⏩	1	50.0%
⏪	1	50.0%

host_id
Real number (ℝ_≥0)

Distinct	16241
Distinct (%)	85.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	66394588.99
Minimum	2571
Maximum	274273284
Zeros	0
Zeros (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	2571
5-th percentile	764688
Q1	7728754
median	30487854
Q3	104835356
95-th percentile	239519185
Maximum	274273284
Range	274270713
Interquartile range (IQR)	97106602

Descriptive statistics

Standard deviation	77826632.15
Coefficient of variation (CV)	1.172183356
Kurtosis	0.2898665825
Mean	66394588.99
Median Absolute Deviation (MAD)	27185317
Skewness	1.245958822
Sum	1.261563585 × 10¹²
Variance	6.056984672 × 10¹⁵
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	117	0.6%
107434423	71	0.4%
30283594	44	0.2%
137358866	36	0.2%
12243051	36	0.2%
61391963	34	0.2%
16098958	33	0.2%
22541573	32	0.2%
26377263	24	0.1%
2856748	22	0.1%
Other values (16231)	18552	97.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2571	1	< 0.1%
2787	3	< 0.1%
3151	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%

Value	Count	Frequency (%)
274273284	1	< 0.1%
274195458	1	< 0.1%
274103383	1	< 0.1%
273870123	1	< 0.1%
273841667	1	< 0.1%

host_name
Categorical

HIGH CARDINALITY

Distinct	6307
Distinct (%)	33.2%
Missing	8
Missing (%)	< 0.1%
Memory size	148.6 KiB

Michael	159
David	157
John	130
Sonder (NYC)	117
Alex	98
Other values (6302)	18332

Length

Max length	35
Median length	6
Mean length	6.100931922
Min length	1

Characters and Unicode

Total characters	115875
Distinct characters	138
Distinct categories	11 ?
Distinct scripts	6 ?
Distinct blocks	7 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4077 ?
Unique (%)	21.5%

Sample

1st row	Iris
2nd row	Johlex
3rd row	John
4th row	Regan
5th row	Megan

Value	Count	Frequency (%)
Michael	159	0.8%
David	157	0.8%
John	130	0.7%
Sonder (NYC)	117	0.6%
Alex	98	0.5%
Daniel	92	0.5%
Sarah	87	0.5%
Maria	86	0.5%
Chris	81	0.4%
Anna	77	0.4%
Other values (6297)	17909	94.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
	401	1.9%
and	234	1.1%
michael	175	0.8%
david	169	0.8%
sonder	153	0.7%
john	145	0.7%
nyc	122	0.6%
alex	121	0.6%
laura	117	0.6%
maria	105	0.5%
Other values (5877)	19369	91.7%

Most occurring characters

Value	Count	Frequency (%)
a	14760	12.7%
e	11187	9.7%
i	9409	8.1%
n	9394	8.1%
r	6989	6.0%
l	5914	5.1%
o	4954	4.3%
t	3638	3.1%
s	3533	3.0%
h	3518	3.0%
Other values (128)	42579	36.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	91499	79.0%
Uppercase Letter	21211	18.3%
Space Separator	2158	1.9%
Other Punctuation	579	0.5%
Open Punctuation	134	0.1%
Close Punctuation	134	0.1%
Dash Punctuation	76	0.1%
Other Letter	39	< 0.1%
Decimal Number	30	< 0.1%
Math Symbol	14	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	14760	16.1%
e	11187	12.2%
i	9409	10.3%
n	9394	10.3%
r	6989	7.6%
l	5914	6.5%
o	4954	5.4%
t	3638	4.0%
s	3533	3.9%
h	3518	3.8%
Other values (46)	18203	19.9%

Value	Count	Frequency (%)
A	2475	11.7%
J	2094	9.9%
M	2051	9.7%
S	1821	8.6%
C	1432	6.8%
L	1124	5.3%
D	1079	5.1%
K	1024	4.8%
R	989	4.7%
E	937	4.4%
Other values (22)	6185	29.2%

Value	Count	Frequency (%)
美	3	7.7%
德	3	7.7%
青	3	7.7%
明	3	7.7%
辣	2	5.1%
柏	2	5.1%
润	2	5.1%
铀	2	5.1%
泽	1	2.6%
宇	1	2.6%
Other values (17)	17	43.6%

Value	Count	Frequency (%)
&	415	71.7%
.	122	21.1%
/	14	2.4%
,	13	2.2%
'	7	1.2%
!	4	0.7%
@	3	0.5%
:	1	0.2%

Value	Count	Frequency (%)
5	7	23.3%
0	5	16.7%
7	5	16.7%
1	4	13.3%
2	3	10.0%
4	3	10.0%
6	2	6.7%
3	1	3.3%

Value	Count	Frequency (%)
	2154	99.8%
	4	0.2%

Value	Count	Frequency (%)
(	134	100.0%

Value	Count	Frequency (%)
)	134	100.0%

Value	Count	Frequency (%)
-	76	100.0%

Value	Count	Frequency (%)
+	14	100.0%

Value	Count	Frequency (%)
£	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	112687	97.2%
Common	3126	2.7%
Han	34	< 0.1%
Cyrillic	23	< 0.1%
Hiragana	3	< 0.1%
Hangul	2	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
a	14760	13.1%
e	11187	9.9%
i	9409	8.3%
n	9394	8.3%
r	6989	6.2%
l	5914	5.2%
o	4954	4.4%
t	3638	3.2%
s	3533	3.1%
h	3518	3.1%
Other values (63)	39391	35.0%

Value	Count	Frequency (%)
	2154	68.9%
&	415	13.3%
(	134	4.3%
)	134	4.3%
.	122	3.9%
-	76	2.4%
+	14	0.4%
/	14	0.4%
,	13	0.4%
5	7	0.2%
Other values (13)	43	1.4%

Value	Count	Frequency (%)
美	3	8.8%
德	3	8.8%
青	3	8.8%
明	3	8.8%
辣	2	5.9%
柏	2	5.9%
润	2	5.9%
铀	2	5.9%
泽	1	2.9%
宇	1	2.9%
Other values (12)	12	35.3%

Value	Count	Frequency (%)
А	3	13.0%
е	3	13.0%
н	2	8.7%
й	2	8.7%
и	2	8.7%
л	2	8.7%
д	1	4.3%
р	1	4.3%
т	1	4.3%
а	1	4.3%
Other values (5)	5	21.7%

Value	Count	Frequency (%)
ゆ	1	33.3%
り	1	33.3%
あ	1	33.3%

Value	Count	Frequency (%)
소	1	50.0%
정	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	115704	99.9%
None	105	0.1%
CJK	34	< 0.1%
Cyrillic	23	< 0.1%
Punctuation	4	< 0.1%
Hiragana	3	< 0.1%
Hangul	2	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
a	14760	12.8%
e	11187	9.7%
i	9409	8.1%
n	9394	8.1%
r	6989	6.0%
l	5914	5.1%
o	4954	4.3%
t	3638	3.1%
s	3533	3.1%
h	3518	3.0%
Other values (63)	42408	36.7%

Value	Count	Frequency (%)
é	42	40.0%
á	10	9.5%
í	9	8.6%
ë	8	7.6%
ô	6	5.7%
è	6	5.7%
ú	5	4.8%
ó	2	1.9%
ç	2	1.9%
ı	2	1.9%
Other values (12)	13	12.4%

Value	Count	Frequency (%)
美	3	8.8%
德	3	8.8%
青	3	8.8%
明	3	8.8%
辣	2	5.9%
柏	2	5.9%
润	2	5.9%
铀	2	5.9%
泽	1	2.9%
宇	1	2.9%
Other values (12)	12	35.3%

Value	Count	Frequency (%)
	4	100.0%

Value	Count	Frequency (%)
А	3	13.0%
е	3	13.0%
н	2	8.7%
й	2	8.7%
и	2	8.7%
л	2	8.7%
д	1	4.3%
р	1	4.3%
т	1	4.3%
а	1	4.3%
Other values (5)	5	21.7%

Value	Count	Frequency (%)
ゆ	1	33.3%
り	1	33.3%
あ	1	33.3%

Value	Count	Frequency (%)
소	1	50.0%
정	1	50.0%

neighbourhood_group
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	148.6 KiB

Brooklyn	8046
Manhattan	8031
Queens	2331
Bronx	434
Staten Island	159

Length

Max length	13
Median length	8
Mean length	8.150623651
Min length	5

Characters and Unicode

Total characters	154870
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Queens
2nd row	Manhattan
3rd row	Manhattan
4th row	Queens
5th row	Brooklyn

Value	Count	Frequency (%)
Brooklyn	8046	42.3%
Manhattan	8031	42.3%
Queens	2331	12.3%
Bronx	434	2.3%
Staten Island	159	0.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
brooklyn	8046	42.0%
manhattan	8031	41.9%
queens	2331	12.2%
bronx	434	2.3%
island	159	0.8%
staten	159	0.8%

Most occurring characters

Value	Count	Frequency (%)
n	27191	17.6%
a	24411	15.8%
o	16526	10.7%
t	16380	10.6%
B	8480	5.5%
r	8480	5.5%
l	8205	5.3%
k	8046	5.2%
y	8046	5.2%
M	8031	5.2%
Other values (10)	21074	13.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	135551	87.5%
Uppercase Letter	19160	12.4%
Space Separator	159	0.1%

Most frequent character per category

Value	Count	Frequency (%)
n	27191	20.1%
a	24411	18.0%
o	16526	12.2%
t	16380	12.1%
r	8480	6.3%
l	8205	6.1%
k	8046	5.9%
y	8046	5.9%
h	8031	5.9%
e	4821	3.6%
Other values (4)	5414	4.0%

Value	Count	Frequency (%)
B	8480	44.3%
M	8031	41.9%
Q	2331	12.2%
S	159	0.8%
I	159	0.8%

Value	Count	Frequency (%)
	159	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	154711	99.9%
Common	159	0.1%

Most frequent character per script

Value	Count	Frequency (%)
n	27191	17.6%
a	24411	15.8%
o	16526	10.7%
t	16380	10.6%
B	8480	5.5%
r	8480	5.5%
l	8205	5.3%
k	8046	5.2%
y	8046	5.2%
M	8031	5.2%
Other values (9)	20915	13.5%

Value	Count	Frequency (%)
	159	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	154870	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	27191	17.6%
a	24411	15.8%
o	16526	10.7%
t	16380	10.6%
B	8480	5.5%
r	8480	5.5%
l	8205	5.3%
k	8046	5.2%
y	8046	5.2%
M	8031	5.2%
Other values (10)	21074	13.6%

neighbourhood
Categorical

HIGH CARDINALITY

Distinct	215
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	148.6 KiB

Williamsburg	1526
Bedford-Stuyvesant	1478
Harlem	1086
Bushwick	978
Upper West Side	734
Other values (210)	13199

Length

Max length	26
Median length	12
Mean length	11.91947792
Min length	4

Characters and Unicode

Total characters	226482
Distinct characters	54
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	0.1%

Sample

1st row	Sunnyside
2nd row	Hell's Kitchen
3rd row	West Village
4th row	Astoria
5th row	Bushwick

Value	Count	Frequency (%)
Williamsburg	1526	8.0%
Bedford-Stuyvesant	1478	7.8%
Harlem	1086	5.7%
Bushwick	978	5.1%
Upper West Side	734	3.9%
East Village	705	3.7%
Hell's Kitchen	693	3.6%
Upper East Side	667	3.5%
Crown Heights	631	3.3%
Midtown	505	2.7%
Other values (205)	9998	52.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
east	2575	8.4%
side	1756	5.7%
harlem	1540	5.0%
williamsburg	1526	5.0%
bedford-stuyvesant	1478	4.8%
heights	1427	4.7%
upper	1401	4.6%
village	1186	3.9%
west	1033	3.4%
bushwick	978	3.2%
Other values (227)	15760	51.4%

Most occurring characters

Value	Count	Frequency (%)
e	20714	9.1%
i	16226	7.2%
s	15652	6.9%
t	15047	6.6%
a	14816	6.5%
l	13284	5.9%
r	13260	5.9%
	11659	5.1%
n	10202	4.5%
o	9383	4.1%
Other values (44)	86239	38.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	179812	79.4%
Uppercase Letter	32558	14.4%
Space Separator	11659	5.1%
Dash Punctuation	1707	0.8%
Other Punctuation	746	0.3%

Most frequent character per category

Value	Count	Frequency (%)
e	20714	11.5%
i	16226	9.0%
s	15652	8.7%
t	15047	8.4%
a	14816	8.2%
l	13284	7.4%
r	13260	7.4%
n	10202	5.7%
o	9383	5.2%
d	7624	4.2%
Other values (15)	43604	24.2%

Value	Count	Frequency (%)
H	4667	14.3%
S	4437	13.6%
B	3298	10.1%
W	3154	9.7%
E	2772	8.5%
C	2107	6.5%
G	1464	4.5%
U	1429	4.4%
F	1324	4.1%
V	1208	3.7%
Other values (14)	6698	20.6%

Value	Count	Frequency (%)
'	697	93.4%
.	48	6.4%
,	1	0.1%

Value	Count	Frequency (%)
	11659	100.0%

Value	Count	Frequency (%)
-	1707	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	212370	93.8%
Common	14112	6.2%

Most frequent character per script

Value	Count	Frequency (%)
e	20714	9.8%
i	16226	7.6%
s	15652	7.4%
t	15047	7.1%
a	14816	7.0%
l	13284	6.3%
r	13260	6.2%
n	10202	4.8%
o	9383	4.4%
d	7624	3.6%
Other values (39)	76162	35.9%

Value	Count	Frequency (%)
	11659	82.6%
-	1707	12.1%
'	697	4.9%
.	48	0.3%
,	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	226482	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	20714	9.1%
i	16226	7.2%
s	15652	6.9%
t	15047	6.6%
a	14816	6.5%
l	13284	5.9%
r	13260	5.9%
	11659	5.1%
n	10202	4.5%
o	9383	4.1%
Other values (44)	86239	38.1%

latitude
Real number (ℝ_≥0)

Distinct	12087
Distinct (%)	63.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	40.72806312
Minimum	40.50873
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	40.50873
5-th percentile	40.64456
Q1	40.68882
median	40.72171
Q3	40.76321
95-th percentile	40.82645
Maximum	40.91306
Range	0.40433
Interquartile range (IQR)	0.07439

Descriptive statistics

Standard deviation	0.05538931047
Coefficient of variation (CV)	0.001359978998
Kurtosis	0.05864487992
Mean	40.72806312
Median Absolute Deviation (MAD)	0.03659
Skewness	0.2542518047
Sum	773873.9274
Variance	0.003067975714
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.72232	8	< 0.1%
40.69414	8	< 0.1%
40.68634	8	< 0.1%
40.71813	8	< 0.1%
40.72607	7	< 0.1%
40.68084	7	< 0.1%
40.68683	7	< 0.1%
40.70741	6	< 0.1%
40.72522	6	< 0.1%
40.72276	6	< 0.1%
Other values (12077)	18930	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40.50873	1	< 0.1%
40.52293	1	< 0.1%
40.53871	1	< 0.1%
40.53939	1	< 0.1%
40.54106	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.90527	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%

longitude
Real number (ℝ)

Distinct	9944
Distinct (%)	52.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-73.95082679
Minimum	-74.23914
Maximum	-73.71795
Zeros	0
Zeros (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	-74.23914
5-th percentile	-74.00369
Q1	-73.98205
median	-73.95463
Q3	-73.93449
95-th percentile	-73.86186
Maximum	-73.71795
Range	0.52119
Interquartile range (IQR)	0.04756

Descriptive statistics

Standard deviation	0.04682498719
Coefficient of variation (CV)	-0.0006331908543
Kurtosis	4.824279693
Mean	-73.95082679
Median Absolute Deviation (MAD)	0.02489
Skewness	1.234020827
Sum	-1405139.66
Variance	0.002192579425
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.95742	9	< 0.1%
-73.95427	9	< 0.1%
-73.95121	9	< 0.1%
-73.95725	9	< 0.1%
-73.98589	9	< 0.1%
-73.94829	9	< 0.1%
-73.95677	8	< 0.1%
-73.94524	8	< 0.1%
-73.9398	8	< 0.1%
-73.95149	8	< 0.1%
Other values (9934)	18915	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-74.23914	1	< 0.1%
-74.21238	1	< 0.1%
-74.19626	1	< 0.1%
-74.18259	1	< 0.1%
-74.17628	1	< 0.1%

Value	Count	Frequency (%)
-73.71795	1	< 0.1%
-73.71829	1	< 0.1%
-73.72582	1	< 0.1%
-73.72716	1	< 0.1%
-73.72731	1	< 0.1%

room_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	148.6 KiB

Entire home/apt	9522
Private room	9041
Shared room	438

Length

Max length	15
Median length	15
Mean length	13.48034314
Min length	11

Characters and Unicode

Total characters	256140
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Private room

Value	Count	Frequency (%)
Entire home/apt	9522	50.1%
Private room	9041	47.6%
Shared room	438	2.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
entire	9522	25.1%
home/apt	9522	25.1%
room	9479	24.9%
private	9041	23.8%
shared	438	1.2%

Most occurring characters

Value	Count	Frequency (%)
e	28523	11.1%
r	28480	11.1%
o	28480	11.1%
t	28085	11.0%
a	19001	7.4%
	19001	7.4%
m	19001	7.4%
i	18563	7.2%
h	9960	3.9%
E	9522	3.7%
Other values (7)	47524	18.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	208616	81.4%
Uppercase Letter	19001	7.4%
Space Separator	19001	7.4%
Other Punctuation	9522	3.7%

Most frequent character per category

Value	Count	Frequency (%)
e	28523	13.7%
r	28480	13.7%
o	28480	13.7%
t	28085	13.5%
a	19001	9.1%
m	19001	9.1%
i	18563	8.9%
h	9960	4.8%
n	9522	4.6%
p	9522	4.6%
Other values (2)	9479	4.5%

Value	Count	Frequency (%)
E	9522	50.1%
P	9041	47.6%
S	438	2.3%

Value	Count	Frequency (%)
	19001	100.0%

Value	Count	Frequency (%)
/	9522	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	227617	88.9%
Common	28523	11.1%

Most frequent character per script

Value	Count	Frequency (%)
e	28523	12.5%
r	28480	12.5%
o	28480	12.5%
t	28085	12.3%
a	19001	8.3%
m	19001	8.3%
i	18563	8.2%
h	9960	4.4%
E	9522	4.2%
n	9522	4.2%
Other values (5)	28480	12.5%

Value	Count	Frequency (%)
	19001	66.6%
/	9522	33.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	256140	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	28523	11.1%
r	28480	11.1%
o	28480	11.1%
t	28085	11.0%
a	19001	7.4%
	19001	7.4%
m	19001	7.4%
i	18563	7.2%
h	9960	3.9%
E	9522	3.7%
Other values (7)	47524	18.6%

price
Real number (ℝ_≥0)

Distinct	321
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	122.3404558
Minimum	10
Maximum	350
Zeros	0
Zeros (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	10
5-th percentile	40
Q1	66
median	100
Q3	160
95-th percentile	270
Maximum	350
Range	340
Interquartile range (IQR)	94

Descriptive statistics

Standard deviation	71.53034564
Coefficient of variation (CV)	0.5846826807
Kurtosis	0.5028006941
Mean	122.3404558
Median Absolute Deviation (MAD)	45
Skewness	1.027024411
Sum	2324591
Variance	5116.590347
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	856	4.5%
150	821	4.3%
50	636	3.3%
200	590	3.1%
75	570	3.0%
60	555	2.9%
80	531	2.8%
70	482	2.5%
120	471	2.5%
65	471	2.5%
Other values (311)	13018	68.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	6	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%

Value	Count	Frequency (%)
350	147	0.8%
349	14	0.1%
348	1	< 0.1%
347	2	< 0.1%
346	1	< 0.1%

minimum_nights
Real number (ℝ_≥0)

ZEROS

Distinct	75
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.121219818
Minimum	0
Maximum	7.13089883
Zeros	5003
Zeros (%)	26.3%
Memory size	148.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.6931471806
Q3	1.609437912
95-th percentile	3.401197382
Maximum	7.13089883
Range	7.13089883
Interquartile range (IQR)	1.609437912

Descriptive statistics

Standard deviation	1.064894555
Coefficient of variation (CV)	0.9497642994
Kurtosis	0.9149991731
Mean	1.121219818
Median Absolute Deviation (MAD)	0.6931471806
Skewness	1.128676634
Sum	21304.29777
Variance	1.134000414
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5003	26.3%
0.6931471806	4619	24.3%
1.098612289	3086	16.2%
3.401197382	1442	7.6%
1.386294361	1253	6.6%
1.609437912	1140	6.0%
1.945910149	822	4.3%
1.791759469	285	1.5%
2.63905733	210	1.1%
2.302585093	178	0.9%
Other values (65)	963	5.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5003	26.3%
0.6931471806	4619	24.3%
1.098612289	3086	16.2%
1.386294361	1253	6.6%
1.609437912	1140	6.0%

Value	Count	Frequency (%)
7.13089883	1	< 0.1%
6.906754779	2	< 0.1%
6.173786104	1	< 0.1%
5.991464547	1	< 0.1%
5.913503006	1	< 0.1%

number_of_reviews
Real number (ℝ_≥0)

ZEROS

Distinct	321
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.79774749
Minimum	0
Maximum	607
Zeros	3758
Zeros (%)	19.8%
Memory size	148.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	24
95-th percentile	116
Maximum	607
Range	607
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	45.49345456
Coefficient of variation (CV)	1.911670614
Kurtosis	19.56592146
Mean	23.79774749
Median Absolute Deviation (MAD)	6
Skewness	3.706018813
Sum	452181
Variance	2069.654408
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3758	19.8%
1	2022	10.6%
2	1342	7.1%
3	975	5.1%
4	796	4.2%
5	589	3.1%
6	544	2.9%
7	495	2.6%
8	449	2.4%
9	383	2.0%
Other values (311)	7648	40.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3758	19.8%
1	2022	10.6%
2	1342	7.1%
3	975	5.1%
4	796	4.2%

Value	Count	Frequency (%)
607	1	< 0.1%
594	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
474	1	< 0.1%

last_review
Date

MISSING

Distinct	1494
Distinct (%)	9.8%
Missing	3758
Missing (%)	19.8%
Memory size	148.6 KiB

Minimum	2011-05-12 00:00:00
Maximum	2019-07-08 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ_≥0)

MISSING

Distinct	789
Distinct (%)	5.2%
Missing	3758
Missing (%)	19.8%
Infinite	0
Infinite (%)	0.0%

Mean	1.380927639
Minimum	0.01
Maximum	27.95
Zeros	0
Zeros (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.19
median	0.72
Q3	2.01
95-th percentile	4.69
Maximum	27.95
Range	27.94
Interquartile range (IQR)	1.82

Descriptive statistics

Standard deviation	1.689988413
Coefficient of variation (CV)	1.22380664
Kurtosis	11.9516004
Mean	1.380927639
Median Absolute Deviation (MAD)	0.62
Skewness	2.435330583
Sum	21049.48
Variance	2.856060837
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	362	1.9%
1	352	1.9%
0.05	333	1.8%
0.03	323	1.7%
0.04	268	1.4%
0.08	256	1.3%
0.16	244	1.3%
0.09	235	1.2%
0.06	226	1.2%
0.11	217	1.1%
Other values (779)	12427	65.4%
(Missing)	3758	19.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	17	0.1%
0.02	362	1.9%
0.03	323	1.7%
0.04	268	1.4%
0.05	333	1.8%

Value	Count	Frequency (%)
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.22	1	< 0.1%

calculated_host_listings_count
Real number (ℝ_≥0)

Distinct	47
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.583811378
Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	13
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	31.15475023
Coefficient of variation (CV)	4.732023511
Kurtosis	77.21481439
Mean	6.583811378
Median Absolute Deviation (MAD)	0
Skewness	8.461222905
Sum	125099
Variance	970.6184621
Monotocity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	12627	66.5%
2	2605	13.7%
3	1123	5.9%
4	539	2.8%
5	345	1.8%
6	208	1.1%
7	165	0.9%
8	164	0.9%
327	117	0.6%
9	98	0.5%
Other values (37)	1010	5.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12627	66.5%
2	2605	13.7%
3	1123	5.9%
4	539	2.8%
5	345	1.8%

Value	Count	Frequency (%)
327	117	0.6%
232	71	0.4%
121	44	0.2%
103	36	0.2%
96	69	0.4%

availability_365
Real number (ℝ_≥0)

ZEROS

Distinct	366
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	109.7253829
Minimum	0
Maximum	365
Zeros	6970
Zeros (%)	36.7%
Memory size	148.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	39
Q3	219
95-th percentile	358
Maximum	365
Range	365
Interquartile range (IQR)	219

Descriptive statistics

Standard deviation	130.5998995
Coefficient of variation (CV)	1.190243279
Kurtosis	-0.9348291358
Mean	109.7253829
Median Absolute Deviation (MAD)	39
Skewness	0.8027018468
Sum	2084892
Variance	17056.33374
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6970	36.7%
365	432	2.3%
364	195	1.0%
1	176	0.9%
5	133	0.7%
3	115	0.6%
2	113	0.6%
179	112	0.6%
89	111	0.6%
6	110	0.6%
Other values (356)	10534	55.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6970	36.7%
1	176	0.9%
2	113	0.6%
3	115	0.6%
4	107	0.6%

Value	Count	Frequency (%)
365	432	2.3%
364	195	1.0%
363	88	0.5%
362	62	0.3%
361	44	0.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	0	9138664	Private Lg Room 15 min to Manhattan	47594947	Iris	Queens	Sunnyside	40.74271	-73.92493	Private room	74	0.693147	6	2019-05-26	0.13	1	5
1	1	31444015	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC	8523790	Johlex	Manhattan	Hell's Kitchen	40.76682	-73.98878	Entire home/apt	170	1.098612	0	NaT	NaN	1	188
2	2	8741020	Voted #1 Location Quintessential 1BR W Village Apt	45854238	John	Manhattan	West Village	40.73631	-74.00611	Entire home/apt	245	1.098612	51	2018-09-19	1.12	1	0
3	3	34602077	Spacious 1 bedroom apartment 15min from Manhattan	261055465	Regan	Queens	Astoria	40.76424	-73.92351	Entire home/apt	125	1.098612	1	2019-05-24	0.65	1	13
4	4	23203149	Big beautiful bedroom in huge Bushwick apartment	143460	Megan	Brooklyn	Bushwick	40.69839	-73.92044	Private room	65	0.693147	8	2019-06-23	0.52	2	8
5	5	4402805	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK	22807362	Jenny	Brooklyn	Prospect-Lefferts Gardens	40.66025	-73.96270	Entire home/apt	120	1.098612	3	2018-08-28	0.05	1	16
6	6	30070126	✩Prime Renovated 1/1 Apartment in Upper East Side✩	4968673	Sean	Manhattan	Upper East Side	40.76831	-73.95929	Entire home/apt	200	1.609438	2	2019-05-26	0.68	1	71
7	7	34231172	Fully renovated brick house floor in Brooklyn	59642348	Kevin	Brooklyn	Sunset Park	40.64550	-74.01262	Entire home/apt	95	0.000000	9	2019-07-08	9.00	1	106
8	8	5856760	Renovated 1BR in exciting, convenient area	29408349	Chad	Manhattan	Chinatown	40.71490	-73.99976	Entire home/apt	179	1.609438	7	2017-04-18	0.14	1	0
9	9	7929441	Beautiful Loft w/ Waterfront View!	1453898	Anthony	Brooklyn	Williamsburg	40.71268	-73.96676	Private room	105	0.693147	232	2019-06-19	5.00	3	64

Last rows

	df_index	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
18991	19990	5192459	Quiet Room in 4BR UWS Brownstone	10677483	Greg	Manhattan	Upper West Side	40.80173	-73.96625	Private room	70	0.000000	0	NaT	NaN	1	0
18992	19991	1327940	Huge Gorgeous Park View Apartment!	3290436	Hadar	Brooklyn	Flatbush	40.65335	-73.96257	Entire home/apt	120	1.098612	13	2016-08-27	0.28	2	327
18993	19992	23612681	Shared Room 1 Stop from Manhattan on the F Train	55724558	Taylor	Queens	Long Island City	40.76006	-73.94080	Private room	55	1.386294	2	2019-06-01	0.65	5	89
18994	19993	34485745	Midtown Manhattan Stunner - Private room	261632622	Royalton	Manhattan	Theater District	40.75491	-73.98507	Private room	100	0.000000	3	2019-06-16	3.00	9	318
18995	19994	25616250	Stylish, spacious, private 1BR apt in Ditmas Park	125396920	Adam	Brooklyn	Flatbush	40.64314	-73.95705	Entire home/apt	75	1.098612	10	2019-01-03	0.84	1	0
18996	19995	7094539	Tranquil haven in bubbly Brooklyn	2052211	Adriana	Brooklyn	Windsor Terrace	40.65360	-73.97546	Entire home/apt	143	2.639057	2	2016-08-27	0.04	1	10
18997	19996	4424261	Large 1 BR with backyard on UWS	3447311	Sarah	Manhattan	Upper West Side	40.80188	-73.96808	Entire home/apt	200	0.693147	22	2019-05-21	0.50	1	0
18998	19997	4545882	Amazing studio/Loft with a backyard	23569951	Kaveh	Manhattan	Upper East Side	40.78110	-73.94567	Entire home/apt	220	1.098612	28	2019-05-23	0.50	1	293
18999	19998	26518547	U2 comfortable double bed sleeps 2 guests	295128	Carol Gloria	Bronx	Clason Point	40.81225	-73.85502	Private room	80	0.000000	4	2019-07-01	1.48	7	365
19000	19999	33631782	Private Bedroom in Williamsburg Apt!	8569221	Andi	Brooklyn	Williamsburg	40.71829	-73.95819	Private room	109	1.098612	3	2019-04-28	1.07	2	97

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows